TfrxBDETable

The component is used for organization of DB table access. The component has the following properties:

Property Description
Active Defines whether a table is active.
DatabaseName DB name.
FieldAliases Enables to set fields aliases.
Filter Expression for records’ filtering.
Filtered Defines whether it is necessary to use filter.
IndexName Secondary index name.
MasterFields Fields connected with master dataset.
Master Master dataset.
SessionName BDE session name.
TableName DB table name.

Component properties’ functions are similar to the "TTable" Delphi properties. To connect a component to the DB table, it is enough to fill the "DatabaseName" and "TableName" properties. Table opening is performed either via the "Active: = True" setting, or with the help of the "Open" method.

The "FieldAliases" property editor allows to select fields, which will be available upon addressing the table, and to set aliases for the whole table and for each field.

The "MasterFields" property editor is used for creation of master-detail connections between two tables. To connect two tables with the master-detail relation, a user should specify a general table in the "Master" property and call the "MasterFields" property editor for the subordinate table. If the table has secondary indexes, which are necessary to be used, set the "IndexName" property beforehand.

Here you can visually bind the "master" and the "detail" fields of data sets. When sets’ connection is of "Master-Detail" type, then when moving within the master set, the contents of the detail set is filtered in a way that it contains only records concerned the current record of the master set.

To connect sets’ fields, select a field from the list on the left (detail set), then a field from the list on the right (master set), and click on the "Add" button. Thus, the fields’ bond would be transferred to the bottom list. To clear the bottom list, use the "Clear" button. The bound fields must be of an equal type and be the key ones.